package com.xxgc.mybatis.dao.extend;

import com.xxgc.mybatis.entity.extend.UserAndMoney;
import com.xxgc.mybatis.entity.extend.UserAndSchool;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserAndSchoolMapper {
    @Select("SELECT `u_name`,`s_name`,`s_site`,`s_type`,`ums_time` \n" +
            "FROM `users`,`school`,`users_mapper_school`\n" +
            "WHERE `u_id`=`ums_u_id` AND `s_id`=`ums_s_id` "  +
            "AND `u_id`=#{uId}")
    List<UserAndSchool> selectByPrimaryKey(Long uId);
}
